package cj.web.portal.dao;
/*
 *  
 *  
*/
import java.util.List;

import net.paoding.rose.jade.annotation.DAO;
import net.paoding.rose.jade.annotation.SQL;
import cj.web.kly.domain.SubjectColumns;

/**
 * 
 * @author 
 *
 */
@DAO
public interface SubjectColumnsVoDAO{
	
	@SQL("SELECT id,pid,subjectId,name FROM SubjectColumns WHERE deleteFlag=1 and status=1 and subjectId=:1 order by orderNo ")
    List<SubjectColumns> queryAll(int subjectId);
	
	@SQL("SELECT a.id,a.pid,a.subjectId,a.name,b.name as subjectName FROM SubjectColumns a join Subject b on a.subjectId =b.id WHERE a.deleteFlag=1 and a.status=1 and a.id=:1 ")
    SubjectColumns queryById(int id);
}